package com.hehui.module.goods.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BaseGoodsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BaseGoodsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBgGoodidIsNull() {
            addCriterion("bg_goodId is null");
            return (Criteria) this;
        }

        public Criteria andBgGoodidIsNotNull() {
            addCriterion("bg_goodId is not null");
            return (Criteria) this;
        }

        public Criteria andBgGoodidEqualTo(Long value) {
            addCriterion("bg_goodId =", value, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidNotEqualTo(Long value) {
            addCriterion("bg_goodId <>", value, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidGreaterThan(Long value) {
            addCriterion("bg_goodId >", value, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_goodId >=", value, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidLessThan(Long value) {
            addCriterion("bg_goodId <", value, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidLessThanOrEqualTo(Long value) {
            addCriterion("bg_goodId <=", value, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidIn(List<Long> values) {
            addCriterion("bg_goodId in", values, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidNotIn(List<Long> values) {
            addCriterion("bg_goodId not in", values, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidBetween(Long value1, Long value2) {
            addCriterion("bg_goodId between", value1, value2, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgGoodidNotBetween(Long value1, Long value2) {
            addCriterion("bg_goodId not between", value1, value2, "bgGoodid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidIsNull() {
            addCriterion("bg_merchantId is null");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidIsNotNull() {
            addCriterion("bg_merchantId is not null");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidEqualTo(Long value) {
            addCriterion("bg_merchantId =", value, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidNotEqualTo(Long value) {
            addCriterion("bg_merchantId <>", value, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidGreaterThan(Long value) {
            addCriterion("bg_merchantId >", value, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_merchantId >=", value, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidLessThan(Long value) {
            addCriterion("bg_merchantId <", value, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidLessThanOrEqualTo(Long value) {
            addCriterion("bg_merchantId <=", value, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidIn(List<Long> values) {
            addCriterion("bg_merchantId in", values, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidNotIn(List<Long> values) {
            addCriterion("bg_merchantId not in", values, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidBetween(Long value1, Long value2) {
            addCriterion("bg_merchantId between", value1, value2, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgMerchantidNotBetween(Long value1, Long value2) {
            addCriterion("bg_merchantId not between", value1, value2, "bgMerchantid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidIsNull() {
            addCriterion("bg_trademarkId is null");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidIsNotNull() {
            addCriterion("bg_trademarkId is not null");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidEqualTo(Long value) {
            addCriterion("bg_trademarkId =", value, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidNotEqualTo(Long value) {
            addCriterion("bg_trademarkId <>", value, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidGreaterThan(Long value) {
            addCriterion("bg_trademarkId >", value, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_trademarkId >=", value, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidLessThan(Long value) {
            addCriterion("bg_trademarkId <", value, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidLessThanOrEqualTo(Long value) {
            addCriterion("bg_trademarkId <=", value, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidIn(List<Long> values) {
            addCriterion("bg_trademarkId in", values, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidNotIn(List<Long> values) {
            addCriterion("bg_trademarkId not in", values, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidBetween(Long value1, Long value2) {
            addCriterion("bg_trademarkId between", value1, value2, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgTrademarkidNotBetween(Long value1, Long value2) {
            addCriterion("bg_trademarkId not between", value1, value2, "bgTrademarkid");
            return (Criteria) this;
        }

        public Criteria andBgInitialIsNull() {
            addCriterion("bg_initial is null");
            return (Criteria) this;
        }

        public Criteria andBgInitialIsNotNull() {
            addCriterion("bg_initial is not null");
            return (Criteria) this;
        }

        public Criteria andBgInitialEqualTo(String value) {
            addCriterion("bg_initial =", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialNotEqualTo(String value) {
            addCriterion("bg_initial <>", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialGreaterThan(String value) {
            addCriterion("bg_initial >", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialGreaterThanOrEqualTo(String value) {
            addCriterion("bg_initial >=", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialLessThan(String value) {
            addCriterion("bg_initial <", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialLessThanOrEqualTo(String value) {
            addCriterion("bg_initial <=", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialLike(String value) {
            addCriterion("bg_initial like", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialNotLike(String value) {
            addCriterion("bg_initial not like", value, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialIn(List<String> values) {
            addCriterion("bg_initial in", values, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialNotIn(List<String> values) {
            addCriterion("bg_initial not in", values, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialBetween(String value1, String value2) {
            addCriterion("bg_initial between", value1, value2, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgInitialNotBetween(String value1, String value2) {
            addCriterion("bg_initial not between", value1, value2, "bgInitial");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameIsNull() {
            addCriterion("bg_goodName is null");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameIsNotNull() {
            addCriterion("bg_goodName is not null");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameEqualTo(String value) {
            addCriterion("bg_goodName =", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameNotEqualTo(String value) {
            addCriterion("bg_goodName <>", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameGreaterThan(String value) {
            addCriterion("bg_goodName >", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameGreaterThanOrEqualTo(String value) {
            addCriterion("bg_goodName >=", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameLessThan(String value) {
            addCriterion("bg_goodName <", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameLessThanOrEqualTo(String value) {
            addCriterion("bg_goodName <=", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameLike(String value) {
            addCriterion("bg_goodName like", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameNotLike(String value) {
            addCriterion("bg_goodName not like", value, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameIn(List<String> values) {
            addCriterion("bg_goodName in", values, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameNotIn(List<String> values) {
            addCriterion("bg_goodName not in", values, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameBetween(String value1, String value2) {
            addCriterion("bg_goodName between", value1, value2, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnameNotBetween(String value1, String value2) {
            addCriterion("bg_goodName not between", value1, value2, "bgGoodname");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumIsNull() {
            addCriterion("bg_goodNum is null");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumIsNotNull() {
            addCriterion("bg_goodNum is not null");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumEqualTo(String value) {
            addCriterion("bg_goodNum =", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumNotEqualTo(String value) {
            addCriterion("bg_goodNum <>", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumGreaterThan(String value) {
            addCriterion("bg_goodNum >", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumGreaterThanOrEqualTo(String value) {
            addCriterion("bg_goodNum >=", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumLessThan(String value) {
            addCriterion("bg_goodNum <", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumLessThanOrEqualTo(String value) {
            addCriterion("bg_goodNum <=", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumLike(String value) {
            addCriterion("bg_goodNum like", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumNotLike(String value) {
            addCriterion("bg_goodNum not like", value, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumIn(List<String> values) {
            addCriterion("bg_goodNum in", values, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumNotIn(List<String> values) {
            addCriterion("bg_goodNum not in", values, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumBetween(String value1, String value2) {
            addCriterion("bg_goodNum between", value1, value2, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodnumNotBetween(String value1, String value2) {
            addCriterion("bg_goodNum not between", value1, value2, "bgGoodnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidIsNull() {
            addCriterion("bg_goodCategoryId is null");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidIsNotNull() {
            addCriterion("bg_goodCategoryId is not null");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidEqualTo(Long value) {
            addCriterion("bg_goodCategoryId =", value, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidNotEqualTo(Long value) {
            addCriterion("bg_goodCategoryId <>", value, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidGreaterThan(Long value) {
            addCriterion("bg_goodCategoryId >", value, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_goodCategoryId >=", value, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidLessThan(Long value) {
            addCriterion("bg_goodCategoryId <", value, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidLessThanOrEqualTo(Long value) {
            addCriterion("bg_goodCategoryId <=", value, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidIn(List<Long> values) {
            addCriterion("bg_goodCategoryId in", values, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidNotIn(List<Long> values) {
            addCriterion("bg_goodCategoryId not in", values, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidBetween(Long value1, Long value2) {
            addCriterion("bg_goodCategoryId between", value1, value2, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgGoodcategoryidNotBetween(Long value1, Long value2) {
            addCriterion("bg_goodCategoryId not between", value1, value2, "bgGoodcategoryid");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitIsNull() {
            addCriterion("bg_isAnyUnit is null");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitIsNotNull() {
            addCriterion("bg_isAnyUnit is not null");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitEqualTo(String value) {
            addCriterion("bg_isAnyUnit =", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitNotEqualTo(String value) {
            addCriterion("bg_isAnyUnit <>", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitGreaterThan(String value) {
            addCriterion("bg_isAnyUnit >", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitGreaterThanOrEqualTo(String value) {
            addCriterion("bg_isAnyUnit >=", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitLessThan(String value) {
            addCriterion("bg_isAnyUnit <", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitLessThanOrEqualTo(String value) {
            addCriterion("bg_isAnyUnit <=", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitLike(String value) {
            addCriterion("bg_isAnyUnit like", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitNotLike(String value) {
            addCriterion("bg_isAnyUnit not like", value, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitIn(List<String> values) {
            addCriterion("bg_isAnyUnit in", values, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitNotIn(List<String> values) {
            addCriterion("bg_isAnyUnit not in", values, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitBetween(String value1, String value2) {
            addCriterion("bg_isAnyUnit between", value1, value2, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgIsanyunitNotBetween(String value1, String value2) {
            addCriterion("bg_isAnyUnit not between", value1, value2, "bgIsanyunit");
            return (Criteria) this;
        }

        public Criteria andBgQidingIsNull() {
            addCriterion("bg_qiDing is null");
            return (Criteria) this;
        }

        public Criteria andBgQidingIsNotNull() {
            addCriterion("bg_qiDing is not null");
            return (Criteria) this;
        }

        public Criteria andBgQidingEqualTo(Integer value) {
            addCriterion("bg_qiDing =", value, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingNotEqualTo(Integer value) {
            addCriterion("bg_qiDing <>", value, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingGreaterThan(Integer value) {
            addCriterion("bg_qiDing >", value, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingGreaterThanOrEqualTo(Integer value) {
            addCriterion("bg_qiDing >=", value, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingLessThan(Integer value) {
            addCriterion("bg_qiDing <", value, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingLessThanOrEqualTo(Integer value) {
            addCriterion("bg_qiDing <=", value, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingIn(List<Integer> values) {
            addCriterion("bg_qiDing in", values, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingNotIn(List<Integer> values) {
            addCriterion("bg_qiDing not in", values, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingBetween(Integer value1, Integer value2) {
            addCriterion("bg_qiDing between", value1, value2, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgQidingNotBetween(Integer value1, Integer value2) {
            addCriterion("bg_qiDing not between", value1, value2, "bgQiding");
            return (Criteria) this;
        }

        public Criteria andBgXiangouIsNull() {
            addCriterion("bg_xianGou is null");
            return (Criteria) this;
        }

        public Criteria andBgXiangouIsNotNull() {
            addCriterion("bg_xianGou is not null");
            return (Criteria) this;
        }

        public Criteria andBgXiangouEqualTo(Integer value) {
            addCriterion("bg_xianGou =", value, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouNotEqualTo(Integer value) {
            addCriterion("bg_xianGou <>", value, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouGreaterThan(Integer value) {
            addCriterion("bg_xianGou >", value, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouGreaterThanOrEqualTo(Integer value) {
            addCriterion("bg_xianGou >=", value, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouLessThan(Integer value) {
            addCriterion("bg_xianGou <", value, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouLessThanOrEqualTo(Integer value) {
            addCriterion("bg_xianGou <=", value, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouIn(List<Integer> values) {
            addCriterion("bg_xianGou in", values, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouNotIn(List<Integer> values) {
            addCriterion("bg_xianGou not in", values, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouBetween(Integer value1, Integer value2) {
            addCriterion("bg_xianGou between", value1, value2, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgXiangouNotBetween(Integer value1, Integer value2) {
            addCriterion("bg_xianGou not between", value1, value2, "bgXiangou");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidIsNull() {
            addCriterion("bg_indexImageId is null");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidIsNotNull() {
            addCriterion("bg_indexImageId is not null");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidEqualTo(Long value) {
            addCriterion("bg_indexImageId =", value, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidNotEqualTo(Long value) {
            addCriterion("bg_indexImageId <>", value, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidGreaterThan(Long value) {
            addCriterion("bg_indexImageId >", value, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_indexImageId >=", value, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidLessThan(Long value) {
            addCriterion("bg_indexImageId <", value, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidLessThanOrEqualTo(Long value) {
            addCriterion("bg_indexImageId <=", value, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidIn(List<Long> values) {
            addCriterion("bg_indexImageId in", values, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidNotIn(List<Long> values) {
            addCriterion("bg_indexImageId not in", values, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidBetween(Long value1, Long value2) {
            addCriterion("bg_indexImageId between", value1, value2, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgIndeximageidNotBetween(Long value1, Long value2) {
            addCriterion("bg_indexImageId not between", value1, value2, "bgIndeximageid");
            return (Criteria) this;
        }

        public Criteria andBgTopIsNull() {
            addCriterion("bg_top is null");
            return (Criteria) this;
        }

        public Criteria andBgTopIsNotNull() {
            addCriterion("bg_top is not null");
            return (Criteria) this;
        }

        public Criteria andBgTopEqualTo(Integer value) {
            addCriterion("bg_top =", value, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopNotEqualTo(Integer value) {
            addCriterion("bg_top <>", value, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopGreaterThan(Integer value) {
            addCriterion("bg_top >", value, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopGreaterThanOrEqualTo(Integer value) {
            addCriterion("bg_top >=", value, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopLessThan(Integer value) {
            addCriterion("bg_top <", value, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopLessThanOrEqualTo(Integer value) {
            addCriterion("bg_top <=", value, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopIn(List<Integer> values) {
            addCriterion("bg_top in", values, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopNotIn(List<Integer> values) {
            addCriterion("bg_top not in", values, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopBetween(Integer value1, Integer value2) {
            addCriterion("bg_top between", value1, value2, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgTopNotBetween(Integer value1, Integer value2) {
            addCriterion("bg_top not between", value1, value2, "bgTop");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingIsNull() {
            addCriterion("bg_isGrounding is null");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingIsNotNull() {
            addCriterion("bg_isGrounding is not null");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingEqualTo(String value) {
            addCriterion("bg_isGrounding =", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingNotEqualTo(String value) {
            addCriterion("bg_isGrounding <>", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingGreaterThan(String value) {
            addCriterion("bg_isGrounding >", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingGreaterThanOrEqualTo(String value) {
            addCriterion("bg_isGrounding >=", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingLessThan(String value) {
            addCriterion("bg_isGrounding <", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingLessThanOrEqualTo(String value) {
            addCriterion("bg_isGrounding <=", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingLike(String value) {
            addCriterion("bg_isGrounding like", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingNotLike(String value) {
            addCriterion("bg_isGrounding not like", value, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingIn(List<String> values) {
            addCriterion("bg_isGrounding in", values, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingNotIn(List<String> values) {
            addCriterion("bg_isGrounding not in", values, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingBetween(String value1, String value2) {
            addCriterion("bg_isGrounding between", value1, value2, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andBgIsgroundingNotBetween(String value1, String value2) {
            addCriterion("bg_isGrounding not between", value1, value2, "bgIsgrounding");
            return (Criteria) this;
        }

        public Criteria andCreatedateIsNull() {
            addCriterion("createDate is null");
            return (Criteria) this;
        }

        public Criteria andCreatedateIsNotNull() {
            addCriterion("createDate is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedateEqualTo(Date value) {
            addCriterion("createDate =", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotEqualTo(Date value) {
            addCriterion("createDate <>", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateGreaterThan(Date value) {
            addCriterion("createDate >", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("createDate >=", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateLessThan(Date value) {
            addCriterion("createDate <", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateLessThanOrEqualTo(Date value) {
            addCriterion("createDate <=", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateIn(List<Date> values) {
            addCriterion("createDate in", values, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotIn(List<Date> values) {
            addCriterion("createDate not in", values, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateBetween(Date value1, Date value2) {
            addCriterion("createDate between", value1, value2, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotBetween(Date value1, Date value2) {
            addCriterion("createDate not between", value1, value2, "createdate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNull() {
            addCriterion("updateDate is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNotNull() {
            addCriterion("updateDate is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateEqualTo(Date value) {
            addCriterion("updateDate =", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotEqualTo(Date value) {
            addCriterion("updateDate <>", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThan(Date value) {
            addCriterion("updateDate >", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("updateDate >=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThan(Date value) {
            addCriterion("updateDate <", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThanOrEqualTo(Date value) {
            addCriterion("updateDate <=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIn(List<Date> values) {
            addCriterion("updateDate in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotIn(List<Date> values) {
            addCriterion("updateDate not in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateBetween(Date value1, Date value2) {
            addCriterion("updateDate between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotBetween(Date value1, Date value2) {
            addCriterion("updateDate not between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNull() {
            addCriterion("is_del is null");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNotNull() {
            addCriterion("is_del is not null");
            return (Criteria) this;
        }

        public Criteria andIsDelEqualTo(String value) {
            addCriterion("is_del =", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotEqualTo(String value) {
            addCriterion("is_del <>", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThan(String value) {
            addCriterion("is_del >", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThanOrEqualTo(String value) {
            addCriterion("is_del >=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThan(String value) {
            addCriterion("is_del <", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThanOrEqualTo(String value) {
            addCriterion("is_del <=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLike(String value) {
            addCriterion("is_del like", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotLike(String value) {
            addCriterion("is_del not like", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelIn(List<String> values) {
            addCriterion("is_del in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotIn(List<String> values) {
            addCriterion("is_del not in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelBetween(String value1, String value2) {
            addCriterion("is_del between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotBetween(String value1, String value2) {
            addCriterion("is_del not between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andBgErpidIsNull() {
            addCriterion("bg_erpId is null");
            return (Criteria) this;
        }

        public Criteria andBgErpidIsNotNull() {
            addCriterion("bg_erpId is not null");
            return (Criteria) this;
        }

        public Criteria andBgErpidEqualTo(String value) {
            addCriterion("bg_erpId =", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidNotEqualTo(String value) {
            addCriterion("bg_erpId <>", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidGreaterThan(String value) {
            addCriterion("bg_erpId >", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidGreaterThanOrEqualTo(String value) {
            addCriterion("bg_erpId >=", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidLessThan(String value) {
            addCriterion("bg_erpId <", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidLessThanOrEqualTo(String value) {
            addCriterion("bg_erpId <=", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidLike(String value) {
            addCriterion("bg_erpId like", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidNotLike(String value) {
            addCriterion("bg_erpId not like", value, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidIn(List<String> values) {
            addCriterion("bg_erpId in", values, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidNotIn(List<String> values) {
            addCriterion("bg_erpId not in", values, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidBetween(String value1, String value2) {
            addCriterion("bg_erpId between", value1, value2, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpidNotBetween(String value1, String value2) {
            addCriterion("bg_erpId not between", value1, value2, "bgErpid");
            return (Criteria) this;
        }

        public Criteria andBgErpnumIsNull() {
            addCriterion("bg_erpNum is null");
            return (Criteria) this;
        }

        public Criteria andBgErpnumIsNotNull() {
            addCriterion("bg_erpNum is not null");
            return (Criteria) this;
        }

        public Criteria andBgErpnumEqualTo(String value) {
            addCriterion("bg_erpNum =", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumNotEqualTo(String value) {
            addCriterion("bg_erpNum <>", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumGreaterThan(String value) {
            addCriterion("bg_erpNum >", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumGreaterThanOrEqualTo(String value) {
            addCriterion("bg_erpNum >=", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumLessThan(String value) {
            addCriterion("bg_erpNum <", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumLessThanOrEqualTo(String value) {
            addCriterion("bg_erpNum <=", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumLike(String value) {
            addCriterion("bg_erpNum like", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumNotLike(String value) {
            addCriterion("bg_erpNum not like", value, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumIn(List<String> values) {
            addCriterion("bg_erpNum in", values, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumNotIn(List<String> values) {
            addCriterion("bg_erpNum not in", values, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumBetween(String value1, String value2) {
            addCriterion("bg_erpNum between", value1, value2, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgErpnumNotBetween(String value1, String value2) {
            addCriterion("bg_erpNum not between", value1, value2, "bgErpnum");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleIsNull() {
            addCriterion("bg_goodMultiple is null");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleIsNotNull() {
            addCriterion("bg_goodMultiple is not null");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleEqualTo(String value) {
            addCriterion("bg_goodMultiple =", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleNotEqualTo(String value) {
            addCriterion("bg_goodMultiple <>", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleGreaterThan(String value) {
            addCriterion("bg_goodMultiple >", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleGreaterThanOrEqualTo(String value) {
            addCriterion("bg_goodMultiple >=", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleLessThan(String value) {
            addCriterion("bg_goodMultiple <", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleLessThanOrEqualTo(String value) {
            addCriterion("bg_goodMultiple <=", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleLike(String value) {
            addCriterion("bg_goodMultiple like", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleNotLike(String value) {
            addCriterion("bg_goodMultiple not like", value, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleIn(List<String> values) {
            addCriterion("bg_goodMultiple in", values, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleNotIn(List<String> values) {
            addCriterion("bg_goodMultiple not in", values, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleBetween(String value1, String value2) {
            addCriterion("bg_goodMultiple between", value1, value2, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgGoodmultipleNotBetween(String value1, String value2) {
            addCriterion("bg_goodMultiple not between", value1, value2, "bgGoodmultiple");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderIsNull() {
            addCriterion("bg_limitOrder is null");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderIsNotNull() {
            addCriterion("bg_limitOrder is not null");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderEqualTo(Integer value) {
            addCriterion("bg_limitOrder =", value, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderNotEqualTo(Integer value) {
            addCriterion("bg_limitOrder <>", value, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderGreaterThan(Integer value) {
            addCriterion("bg_limitOrder >", value, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderGreaterThanOrEqualTo(Integer value) {
            addCriterion("bg_limitOrder >=", value, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderLessThan(Integer value) {
            addCriterion("bg_limitOrder <", value, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderLessThanOrEqualTo(Integer value) {
            addCriterion("bg_limitOrder <=", value, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderIn(List<Integer> values) {
            addCriterion("bg_limitOrder in", values, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderNotIn(List<Integer> values) {
            addCriterion("bg_limitOrder not in", values, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderBetween(Integer value1, Integer value2) {
            addCriterion("bg_limitOrder between", value1, value2, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgLimitorderNotBetween(Integer value1, Integer value2) {
            addCriterion("bg_limitOrder not between", value1, value2, "bgLimitorder");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightIsNull() {
            addCriterion("bg_goodsWeight is null");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightIsNotNull() {
            addCriterion("bg_goodsWeight is not null");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightEqualTo(String value) {
            addCriterion("bg_goodsWeight =", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightNotEqualTo(String value) {
            addCriterion("bg_goodsWeight <>", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightGreaterThan(String value) {
            addCriterion("bg_goodsWeight >", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightGreaterThanOrEqualTo(String value) {
            addCriterion("bg_goodsWeight >=", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightLessThan(String value) {
            addCriterion("bg_goodsWeight <", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightLessThanOrEqualTo(String value) {
            addCriterion("bg_goodsWeight <=", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightLike(String value) {
            addCriterion("bg_goodsWeight like", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightNotLike(String value) {
            addCriterion("bg_goodsWeight not like", value, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightIn(List<String> values) {
            addCriterion("bg_goodsWeight in", values, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightNotIn(List<String> values) {
            addCriterion("bg_goodsWeight not in", values, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightBetween(String value1, String value2) {
            addCriterion("bg_goodsWeight between", value1, value2, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgGoodsweightNotBetween(String value1, String value2) {
            addCriterion("bg_goodsWeight not between", value1, value2, "bgGoodsweight");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionIsNull() {
            addCriterion("bg_dateOfProduction is null");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionIsNotNull() {
            addCriterion("bg_dateOfProduction is not null");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionEqualTo(String value) {
            addCriterion("bg_dateOfProduction =", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionNotEqualTo(String value) {
            addCriterion("bg_dateOfProduction <>", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionGreaterThan(String value) {
            addCriterion("bg_dateOfProduction >", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionGreaterThanOrEqualTo(String value) {
            addCriterion("bg_dateOfProduction >=", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionLessThan(String value) {
            addCriterion("bg_dateOfProduction <", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionLessThanOrEqualTo(String value) {
            addCriterion("bg_dateOfProduction <=", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionLike(String value) {
            addCriterion("bg_dateOfProduction like", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionNotLike(String value) {
            addCriterion("bg_dateOfProduction not like", value, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionIn(List<String> values) {
            addCriterion("bg_dateOfProduction in", values, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionNotIn(List<String> values) {
            addCriterion("bg_dateOfProduction not in", values, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionBetween(String value1, String value2) {
            addCriterion("bg_dateOfProduction between", value1, value2, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofproductionNotBetween(String value1, String value2) {
            addCriterion("bg_dateOfProduction not between", value1, value2, "bgDateofproduction");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureIsNull() {
            addCriterion("bg_dateOfManufacture is null");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureIsNotNull() {
            addCriterion("bg_dateOfManufacture is not null");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureEqualTo(String value) {
            addCriterion("bg_dateOfManufacture =", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureNotEqualTo(String value) {
            addCriterion("bg_dateOfManufacture <>", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureGreaterThan(String value) {
            addCriterion("bg_dateOfManufacture >", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureGreaterThanOrEqualTo(String value) {
            addCriterion("bg_dateOfManufacture >=", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureLessThan(String value) {
            addCriterion("bg_dateOfManufacture <", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureLessThanOrEqualTo(String value) {
            addCriterion("bg_dateOfManufacture <=", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureLike(String value) {
            addCriterion("bg_dateOfManufacture like", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureNotLike(String value) {
            addCriterion("bg_dateOfManufacture not like", value, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureIn(List<String> values) {
            addCriterion("bg_dateOfManufacture in", values, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureNotIn(List<String> values) {
            addCriterion("bg_dateOfManufacture not in", values, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureBetween(String value1, String value2) {
            addCriterion("bg_dateOfManufacture between", value1, value2, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgDateofmanufactureNotBetween(String value1, String value2) {
            addCriterion("bg_dateOfManufacture not between", value1, value2, "bgDateofmanufacture");
            return (Criteria) this;
        }

        public Criteria andBgTypeIsNull() {
            addCriterion("bg_type is null");
            return (Criteria) this;
        }

        public Criteria andBgTypeIsNotNull() {
            addCriterion("bg_type is not null");
            return (Criteria) this;
        }

        public Criteria andBgTypeEqualTo(String value) {
            addCriterion("bg_type =", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeNotEqualTo(String value) {
            addCriterion("bg_type <>", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeGreaterThan(String value) {
            addCriterion("bg_type >", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeGreaterThanOrEqualTo(String value) {
            addCriterion("bg_type >=", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeLessThan(String value) {
            addCriterion("bg_type <", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeLessThanOrEqualTo(String value) {
            addCriterion("bg_type <=", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeLike(String value) {
            addCriterion("bg_type like", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeNotLike(String value) {
            addCriterion("bg_type not like", value, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeIn(List<String> values) {
            addCriterion("bg_type in", values, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeNotIn(List<String> values) {
            addCriterion("bg_type not in", values, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeBetween(String value1, String value2) {
            addCriterion("bg_type between", value1, value2, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgTypeNotBetween(String value1, String value2) {
            addCriterion("bg_type not between", value1, value2, "bgType");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsIsNull() {
            addCriterion("bg_alternateUnits is null");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsIsNotNull() {
            addCriterion("bg_alternateUnits is not null");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsEqualTo(String value) {
            addCriterion("bg_alternateUnits =", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsNotEqualTo(String value) {
            addCriterion("bg_alternateUnits <>", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsGreaterThan(String value) {
            addCriterion("bg_alternateUnits >", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsGreaterThanOrEqualTo(String value) {
            addCriterion("bg_alternateUnits >=", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsLessThan(String value) {
            addCriterion("bg_alternateUnits <", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsLessThanOrEqualTo(String value) {
            addCriterion("bg_alternateUnits <=", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsLike(String value) {
            addCriterion("bg_alternateUnits like", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsNotLike(String value) {
            addCriterion("bg_alternateUnits not like", value, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsIn(List<String> values) {
            addCriterion("bg_alternateUnits in", values, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsNotIn(List<String> values) {
            addCriterion("bg_alternateUnits not in", values, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsBetween(String value1, String value2) {
            addCriterion("bg_alternateUnits between", value1, value2, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgAlternateunitsNotBetween(String value1, String value2) {
            addCriterion("bg_alternateUnits not between", value1, value2, "bgAlternateunits");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceIsNull() {
            addCriterion("bg_orderPrice is null");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceIsNotNull() {
            addCriterion("bg_orderPrice is not null");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceEqualTo(Double value) {
            addCriterion("bg_orderPrice =", value, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceNotEqualTo(Double value) {
            addCriterion("bg_orderPrice <>", value, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceGreaterThan(Double value) {
            addCriterion("bg_orderPrice >", value, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("bg_orderPrice >=", value, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceLessThan(Double value) {
            addCriterion("bg_orderPrice <", value, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceLessThanOrEqualTo(Double value) {
            addCriterion("bg_orderPrice <=", value, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceIn(List<Double> values) {
            addCriterion("bg_orderPrice in", values, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceNotIn(List<Double> values) {
            addCriterion("bg_orderPrice not in", values, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceBetween(Double value1, Double value2) {
            addCriterion("bg_orderPrice between", value1, value2, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgOrderpriceNotBetween(Double value1, Double value2) {
            addCriterion("bg_orderPrice not between", value1, value2, "bgOrderprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceIsNull() {
            addCriterion("bg_marketPrice is null");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceIsNotNull() {
            addCriterion("bg_marketPrice is not null");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceEqualTo(Double value) {
            addCriterion("bg_marketPrice =", value, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceNotEqualTo(Double value) {
            addCriterion("bg_marketPrice <>", value, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceGreaterThan(Double value) {
            addCriterion("bg_marketPrice >", value, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("bg_marketPrice >=", value, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceLessThan(Double value) {
            addCriterion("bg_marketPrice <", value, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceLessThanOrEqualTo(Double value) {
            addCriterion("bg_marketPrice <=", value, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceIn(List<Double> values) {
            addCriterion("bg_marketPrice in", values, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceNotIn(List<Double> values) {
            addCriterion("bg_marketPrice not in", values, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceBetween(Double value1, Double value2) {
            addCriterion("bg_marketPrice between", value1, value2, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgMarketpriceNotBetween(Double value1, Double value2) {
            addCriterion("bg_marketPrice not between", value1, value2, "bgMarketprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceIsNull() {
            addCriterion("bg_purchasePrice is null");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceIsNotNull() {
            addCriterion("bg_purchasePrice is not null");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceEqualTo(Double value) {
            addCriterion("bg_purchasePrice =", value, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceNotEqualTo(Double value) {
            addCriterion("bg_purchasePrice <>", value, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceGreaterThan(Double value) {
            addCriterion("bg_purchasePrice >", value, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceGreaterThanOrEqualTo(Double value) {
            addCriterion("bg_purchasePrice >=", value, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceLessThan(Double value) {
            addCriterion("bg_purchasePrice <", value, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceLessThanOrEqualTo(Double value) {
            addCriterion("bg_purchasePrice <=", value, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceIn(List<Double> values) {
            addCriterion("bg_purchasePrice in", values, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceNotIn(List<Double> values) {
            addCriterion("bg_purchasePrice not in", values, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceBetween(Double value1, Double value2) {
            addCriterion("bg_purchasePrice between", value1, value2, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgPurchasepriceNotBetween(Double value1, Double value2) {
            addCriterion("bg_purchasePrice not between", value1, value2, "bgPurchaseprice");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersIsNull() {
            addCriterion("bg_suppliers is null");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersIsNotNull() {
            addCriterion("bg_suppliers is not null");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersEqualTo(String value) {
            addCriterion("bg_suppliers =", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersNotEqualTo(String value) {
            addCriterion("bg_suppliers <>", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersGreaterThan(String value) {
            addCriterion("bg_suppliers >", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersGreaterThanOrEqualTo(String value) {
            addCriterion("bg_suppliers >=", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersLessThan(String value) {
            addCriterion("bg_suppliers <", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersLessThanOrEqualTo(String value) {
            addCriterion("bg_suppliers <=", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersLike(String value) {
            addCriterion("bg_suppliers like", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersNotLike(String value) {
            addCriterion("bg_suppliers not like", value, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersIn(List<String> values) {
            addCriterion("bg_suppliers in", values, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersNotIn(List<String> values) {
            addCriterion("bg_suppliers not in", values, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersBetween(String value1, String value2) {
            addCriterion("bg_suppliers between", value1, value2, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgSuppliersNotBetween(String value1, String value2) {
            addCriterion("bg_suppliers not between", value1, value2, "bgSuppliers");
            return (Criteria) this;
        }

        public Criteria andBgLabelingIsNull() {
            addCriterion("bg_labeling is null");
            return (Criteria) this;
        }

        public Criteria andBgLabelingIsNotNull() {
            addCriterion("bg_labeling is not null");
            return (Criteria) this;
        }

        public Criteria andBgLabelingEqualTo(String value) {
            addCriterion("bg_labeling =", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingNotEqualTo(String value) {
            addCriterion("bg_labeling <>", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingGreaterThan(String value) {
            addCriterion("bg_labeling >", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingGreaterThanOrEqualTo(String value) {
            addCriterion("bg_labeling >=", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingLessThan(String value) {
            addCriterion("bg_labeling <", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingLessThanOrEqualTo(String value) {
            addCriterion("bg_labeling <=", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingLike(String value) {
            addCriterion("bg_labeling like", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingNotLike(String value) {
            addCriterion("bg_labeling not like", value, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingIn(List<String> values) {
            addCriterion("bg_labeling in", values, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingNotIn(List<String> values) {
            addCriterion("bg_labeling not in", values, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingBetween(String value1, String value2) {
            addCriterion("bg_labeling between", value1, value2, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLabelingNotBetween(String value1, String value2) {
            addCriterion("bg_labeling not between", value1, value2, "bgLabeling");
            return (Criteria) this;
        }

        public Criteria andBgLocationIsNull() {
            addCriterion("bg_location is null");
            return (Criteria) this;
        }

        public Criteria andBgLocationIsNotNull() {
            addCriterion("bg_location is not null");
            return (Criteria) this;
        }

        public Criteria andBgLocationEqualTo(String value) {
            addCriterion("bg_location =", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationNotEqualTo(String value) {
            addCriterion("bg_location <>", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationGreaterThan(String value) {
            addCriterion("bg_location >", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationGreaterThanOrEqualTo(String value) {
            addCriterion("bg_location >=", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationLessThan(String value) {
            addCriterion("bg_location <", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationLessThanOrEqualTo(String value) {
            addCriterion("bg_location <=", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationLike(String value) {
            addCriterion("bg_location like", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationNotLike(String value) {
            addCriterion("bg_location not like", value, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationIn(List<String> values) {
            addCriterion("bg_location in", values, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationNotIn(List<String> values) {
            addCriterion("bg_location not in", values, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationBetween(String value1, String value2) {
            addCriterion("bg_location between", value1, value2, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgLocationNotBetween(String value1, String value2) {
            addCriterion("bg_location not between", value1, value2, "bgLocation");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkIsNull() {
            addCriterion("bg_productLink is null");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkIsNotNull() {
            addCriterion("bg_productLink is not null");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkEqualTo(String value) {
            addCriterion("bg_productLink =", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkNotEqualTo(String value) {
            addCriterion("bg_productLink <>", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkGreaterThan(String value) {
            addCriterion("bg_productLink >", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkGreaterThanOrEqualTo(String value) {
            addCriterion("bg_productLink >=", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkLessThan(String value) {
            addCriterion("bg_productLink <", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkLessThanOrEqualTo(String value) {
            addCriterion("bg_productLink <=", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkLike(String value) {
            addCriterion("bg_productLink like", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkNotLike(String value) {
            addCriterion("bg_productLink not like", value, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkIn(List<String> values) {
            addCriterion("bg_productLink in", values, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkNotIn(List<String> values) {
            addCriterion("bg_productLink not in", values, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkBetween(String value1, String value2) {
            addCriterion("bg_productLink between", value1, value2, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgProductlinkNotBetween(String value1, String value2) {
            addCriterion("bg_productLink not between", value1, value2, "bgProductlink");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionIsNull() {
            addCriterion("bg_graphicDescription is null");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionIsNotNull() {
            addCriterion("bg_graphicDescription is not null");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionEqualTo(String value) {
            addCriterion("bg_graphicDescription =", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionNotEqualTo(String value) {
            addCriterion("bg_graphicDescription <>", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionGreaterThan(String value) {
            addCriterion("bg_graphicDescription >", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("bg_graphicDescription >=", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionLessThan(String value) {
            addCriterion("bg_graphicDescription <", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionLessThanOrEqualTo(String value) {
            addCriterion("bg_graphicDescription <=", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionLike(String value) {
            addCriterion("bg_graphicDescription like", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionNotLike(String value) {
            addCriterion("bg_graphicDescription not like", value, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionIn(List<String> values) {
            addCriterion("bg_graphicDescription in", values, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionNotIn(List<String> values) {
            addCriterion("bg_graphicDescription not in", values, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionBetween(String value1, String value2) {
            addCriterion("bg_graphicDescription between", value1, value2, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgGraphicdescriptionNotBetween(String value1, String value2) {
            addCriterion("bg_graphicDescription not between", value1, value2, "bgGraphicdescription");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseIsNull() {
            addCriterion("bg_defauWarehouse is null");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseIsNotNull() {
            addCriterion("bg_defauWarehouse is not null");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseEqualTo(Long value) {
            addCriterion("bg_defauWarehouse =", value, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseNotEqualTo(Long value) {
            addCriterion("bg_defauWarehouse <>", value, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseGreaterThan(Long value) {
            addCriterion("bg_defauWarehouse >", value, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_defauWarehouse >=", value, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseLessThan(Long value) {
            addCriterion("bg_defauWarehouse <", value, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseLessThanOrEqualTo(Long value) {
            addCriterion("bg_defauWarehouse <=", value, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseIn(List<Long> values) {
            addCriterion("bg_defauWarehouse in", values, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseNotIn(List<Long> values) {
            addCriterion("bg_defauWarehouse not in", values, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseBetween(Long value1, Long value2) {
            addCriterion("bg_defauWarehouse between", value1, value2, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgDefauwarehouseNotBetween(Long value1, Long value2) {
            addCriterion("bg_defauWarehouse not between", value1, value2, "bgDefauwarehouse");
            return (Criteria) this;
        }

        public Criteria andBgUnitIsNull() {
            addCriterion("bg_unit is null");
            return (Criteria) this;
        }

        public Criteria andBgUnitIsNotNull() {
            addCriterion("bg_unit is not null");
            return (Criteria) this;
        }

        public Criteria andBgUnitEqualTo(Long value) {
            addCriterion("bg_unit =", value, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitNotEqualTo(Long value) {
            addCriterion("bg_unit <>", value, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitGreaterThan(Long value) {
            addCriterion("bg_unit >", value, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_unit >=", value, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitLessThan(Long value) {
            addCriterion("bg_unit <", value, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitLessThanOrEqualTo(Long value) {
            addCriterion("bg_unit <=", value, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitIn(List<Long> values) {
            addCriterion("bg_unit in", values, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitNotIn(List<Long> values) {
            addCriterion("bg_unit not in", values, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitBetween(Long value1, Long value2) {
            addCriterion("bg_unit between", value1, value2, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgUnitNotBetween(Long value1, Long value2) {
            addCriterion("bg_unit not between", value1, value2, "bgUnit");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelIsNull() {
            addCriterion("bg_randLabel is null");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelIsNotNull() {
            addCriterion("bg_randLabel is not null");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelEqualTo(Long value) {
            addCriterion("bg_randLabel =", value, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelNotEqualTo(Long value) {
            addCriterion("bg_randLabel <>", value, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelGreaterThan(Long value) {
            addCriterion("bg_randLabel >", value, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelGreaterThanOrEqualTo(Long value) {
            addCriterion("bg_randLabel >=", value, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelLessThan(Long value) {
            addCriterion("bg_randLabel <", value, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelLessThanOrEqualTo(Long value) {
            addCriterion("bg_randLabel <=", value, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelIn(List<Long> values) {
            addCriterion("bg_randLabel in", values, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelNotIn(List<Long> values) {
            addCriterion("bg_randLabel not in", values, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelBetween(Long value1, Long value2) {
            addCriterion("bg_randLabel between", value1, value2, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgRandlabelNotBetween(Long value1, Long value2) {
            addCriterion("bg_randLabel not between", value1, value2, "bgRandlabel");
            return (Criteria) this;
        }

        public Criteria andBgIsladderIsNull() {
            addCriterion("bg_isLadder is null");
            return (Criteria) this;
        }

        public Criteria andBgIsladderIsNotNull() {
            addCriterion("bg_isLadder is not null");
            return (Criteria) this;
        }

        public Criteria andBgIsladderEqualTo(String value) {
            addCriterion("bg_isLadder =", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderNotEqualTo(String value) {
            addCriterion("bg_isLadder <>", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderGreaterThan(String value) {
            addCriterion("bg_isLadder >", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderGreaterThanOrEqualTo(String value) {
            addCriterion("bg_isLadder >=", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderLessThan(String value) {
            addCriterion("bg_isLadder <", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderLessThanOrEqualTo(String value) {
            addCriterion("bg_isLadder <=", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderLike(String value) {
            addCriterion("bg_isLadder like", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderNotLike(String value) {
            addCriterion("bg_isLadder not like", value, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderIn(List<String> values) {
            addCriterion("bg_isLadder in", values, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderNotIn(List<String> values) {
            addCriterion("bg_isLadder not in", values, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderBetween(String value1, String value2) {
            addCriterion("bg_isLadder between", value1, value2, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIsladderNotBetween(String value1, String value2) {
            addCriterion("bg_isLadder not between", value1, value2, "bgIsladder");
            return (Criteria) this;
        }

        public Criteria andBgIslevelIsNull() {
            addCriterion("bg__islevel is null");
            return (Criteria) this;
        }

        public Criteria andBgIslevelIsNotNull() {
            addCriterion("bg__islevel is not null");
            return (Criteria) this;
        }

        public Criteria andBgIslevelEqualTo(String value) {
            addCriterion("bg__islevel =", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelNotEqualTo(String value) {
            addCriterion("bg__islevel <>", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelGreaterThan(String value) {
            addCriterion("bg__islevel >", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelGreaterThanOrEqualTo(String value) {
            addCriterion("bg__islevel >=", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelLessThan(String value) {
            addCriterion("bg__islevel <", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelLessThanOrEqualTo(String value) {
            addCriterion("bg__islevel <=", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelLike(String value) {
            addCriterion("bg__islevel like", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelNotLike(String value) {
            addCriterion("bg__islevel not like", value, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelIn(List<String> values) {
            addCriterion("bg__islevel in", values, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelNotIn(List<String> values) {
            addCriterion("bg__islevel not in", values, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelBetween(String value1, String value2) {
            addCriterion("bg__islevel between", value1, value2, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIslevelNotBetween(String value1, String value2) {
            addCriterion("bg__islevel not between", value1, value2, "bgIslevel");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyIsNull() {
            addCriterion("bg_isSpecify is null");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyIsNotNull() {
            addCriterion("bg_isSpecify is not null");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyEqualTo(String value) {
            addCriterion("bg_isSpecify =", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyNotEqualTo(String value) {
            addCriterion("bg_isSpecify <>", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyGreaterThan(String value) {
            addCriterion("bg_isSpecify >", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyGreaterThanOrEqualTo(String value) {
            addCriterion("bg_isSpecify >=", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyLessThan(String value) {
            addCriterion("bg_isSpecify <", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyLessThanOrEqualTo(String value) {
            addCriterion("bg_isSpecify <=", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyLike(String value) {
            addCriterion("bg_isSpecify like", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyNotLike(String value) {
            addCriterion("bg_isSpecify not like", value, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyIn(List<String> values) {
            addCriterion("bg_isSpecify in", values, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyNotIn(List<String> values) {
            addCriterion("bg_isSpecify not in", values, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyBetween(String value1, String value2) {
            addCriterion("bg_isSpecify between", value1, value2, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgIsspecifyNotBetween(String value1, String value2) {
            addCriterion("bg_isSpecify not between", value1, value2, "bgIsspecify");
            return (Criteria) this;
        }

        public Criteria andBgKeywordIsNull() {
            addCriterion("bg_keyword is null");
            return (Criteria) this;
        }

        public Criteria andBgKeywordIsNotNull() {
            addCriterion("bg_keyword is not null");
            return (Criteria) this;
        }

        public Criteria andBgKeywordEqualTo(String value) {
            addCriterion("bg_keyword =", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordNotEqualTo(String value) {
            addCriterion("bg_keyword <>", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordGreaterThan(String value) {
            addCriterion("bg_keyword >", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordGreaterThanOrEqualTo(String value) {
            addCriterion("bg_keyword >=", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordLessThan(String value) {
            addCriterion("bg_keyword <", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordLessThanOrEqualTo(String value) {
            addCriterion("bg_keyword <=", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordLike(String value) {
            addCriterion("bg_keyword like", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordNotLike(String value) {
            addCriterion("bg_keyword not like", value, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordIn(List<String> values) {
            addCriterion("bg_keyword in", values, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordNotIn(List<String> values) {
            addCriterion("bg_keyword not in", values, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordBetween(String value1, String value2) {
            addCriterion("bg_keyword between", value1, value2, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgKeywordNotBetween(String value1, String value2) {
            addCriterion("bg_keyword not between", value1, value2, "bgKeyword");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeIsNull() {
            addCriterion("bg_barCode is null");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeIsNotNull() {
            addCriterion("bg_barCode is not null");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeEqualTo(String value) {
            addCriterion("bg_barCode =", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeNotEqualTo(String value) {
            addCriterion("bg_barCode <>", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeGreaterThan(String value) {
            addCriterion("bg_barCode >", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeGreaterThanOrEqualTo(String value) {
            addCriterion("bg_barCode >=", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeLessThan(String value) {
            addCriterion("bg_barCode <", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeLessThanOrEqualTo(String value) {
            addCriterion("bg_barCode <=", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeLike(String value) {
            addCriterion("bg_barCode like", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeNotLike(String value) {
            addCriterion("bg_barCode not like", value, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeIn(List<String> values) {
            addCriterion("bg_barCode in", values, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeNotIn(List<String> values) {
            addCriterion("bg_barCode not in", values, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeBetween(String value1, String value2) {
            addCriterion("bg_barCode between", value1, value2, "bgBarcode");
            return (Criteria) this;
        }

        public Criteria andBgBarcodeNotBetween(String value1, String value2) {
            addCriterion("bg_barCode not between", value1, value2, "bgBarcode");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}